[istore221]

in my database (MYSQL) i have a field

this field is in non english format (it can store english but im inserting sinhala (sri lanka)

FirstName TEXT CHARACTER SET ucs2 COLLATE ucs2_unicode_ci,

when i insert a record manually it works fine
but when i insert the record via pregame its shown like this

FirstName
?????

but when i insert manually directly via database it works fine

this is my code so far

connection_to_Visual_dataset_sec.insertSinhalaQ("හලො");

[Skydiver]

How are you displaying the data via "pregame"? Are you using a textbox or data grid view? Is your program's locale set something that matches your character set? Does the font you are using for your UI support those glyphs?

[istore221]

Skydiver, on 10 February 2013 - 09:31 AM, said:

How are you displaying the data via "pregame"? Are you using a textbox or data grid view? Is your program's locale set something that matches your character set? Does the font you are using for your UI support those glyphs?

Thank you very much for your reply problem solved