MySQL - question marks inserted instead of cyrillic -


i've read through several time previous questions on , tried suggested, issue still persists.

i have mysql db , second-party app inserts data db. worked ok until decided delete entire database , create new empty database forward engineering mysql model. after modification, second-party app began insert question marks instead of cyrillic. however, if try manually insert cyrillic, it's ok.

i don't have access source code of second-party app. , - - had, issue not in second-party app, since emphasizing once more - before deleting , recreating database, worked ok.

i tried following:

1) 

set global character_set_client = 'utf8'; set global character_set_results = 'utf8'; set global character_set_server = 'utf8'; set global character_set_database = 'utf8' set global character_set_connection = 'utf8'

2) 

alter database my_db_name character set utf8 collate utf8_general_ci; alter table table_of_interest_name convert character set utf8 collate utf8_general_ci;

after of modification, tried restart apache. in case. missing ?!! me please

what have done set default. need chance collation of columns

alter table t1 modify col1 varchar(5) character set latin1 collate latin1_swedish_ci

from docs

http://dev.mysql.com/doc/refman/5.7/en/charset-column.html


-

Comments

Post a Comment

Popular posts from this blog

amazon web services - S3 Pre-signed POST validate file type? -

i know it's possible put limit on file size content-length-range header. possible validate file type? https://docs.aws.amazon.com/amazons3/latest/dev/httppostforms.html#policyconditions i see there content-type header, if set say, audio/mp3 allow mp3 files , return error if file not mp3? i found previous question answers mention validating file size: s3 direct upload restricting file size , type you can specify content-type @ post request. you can specify @ signature, post must done content-type: { "expiration": "2007-12-01t12:00:00.000z", "conditions": [ {"acl": "public-read" }, {"bucket": "johnsmith" }, {"content-type: "audio/mp3"} ] } creating html form (using aws signature version 4) edit: @ previous question found, checking content-type.
Read more

c# - Check Keyboard Input Winforms -

i wondering if instead of doing this protected override void onkeydown(keyeventargs e) { if (e.keycode == keys.a) console.writeline("the key down."); } i set bool method , this: if(keydown(keys.a)) // whatever here i've been sitting here ages trying figure out how it. can't wrap head around it. in case wondering, plan call bool inside different method, check input. since want perform action after pressing key, using keydown event enough. but in cases suppose want check if specific key down in middle of process, can use getkeystate method way: [dllimport("user32.dll", charset = charset.auto, exactspelling = true)] public static extern short getkeystate(int keycode); public const int key_pressed = 0x8000; public static bool iskeydown(keys key) { return convert.toboolean(getkeystate((int)key) & key_pressed); } you should know, each time check key state using example iskeydown(keys.a) method returns true if ke...
Read more