Member Avatar for Anigmalee

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

  • 1 Contributor
  • 1 Reply
  • 106 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Anigmalee
Member Avatar for Anigmalee

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.