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