Memo field unicode problem
Posted: 06.07.2012, 10:19
I'm using Delphi XE2 and latest zeos 7 from SVN. I have problem with unicode characters in memo field. Database is mySQL 4.1.
I use DBAdvGrid from TMSSoftware to show data. When i open my query in grid, unicode characters stored in memo field are shown as trash. When i show that characters in edit control using only they are also shown as trash, but when i convert value to ansistring with , data is shown as it should be...
Can someone check this and tell me what is going on? This happens only with memo fields.
I use DBAdvGrid from TMSSoftware to show data. When i open my query in grid, unicode characters stored in memo field are shown as trash. When i show that characters in edit control using only
Code: Select all
Edit.Text := Field.AsString
Code: Select all
Edit.Text := Utf8ToAnsi(Field.AsString)
Can someone check this and tell me what is going on? This happens only with memo fields.