Start New Discussion within our Software Development Community

Hi All,

I try to store Korean langguage in Microsoft jet OLEDB 4.0 database, but I cant retrive it back.

catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=" & sDatabaseToCreate & _
            ";Jet OLEDB:Engine Type=5;")

I try to google around for weeks..but still cant find the solution, I believe microsoft jet 4.0 should support unicode, but cant find any command like charset to set the character set. I've try store with DataTypeEnum.adVarWChar/DataTypeEnum.adWChar/DataTypeEnum.adLongVarWChar. I've set the regional and lagguage setting to korean(I can view korean in textpad). I've try

System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("ko-KR")

before retrive korean string also.

now i have totaly no clue. just suspect, i need to do something when create the database or when read from the database, but dont know how.

Any hint is welcome:o Thanks

Errrr....after i try change the datatype to adVarWChar or adWChar, display is fine.

(I use MEMO before it). haha....i think case close.:)

This question has already been answered. Start a new discussion instead.