Problem in displaying and storing Hindi language in MS Access

[ashish_access]

I need to create a form in hindi language in ms access .Also I need to store hindi text(in unicode) in database.
Please suggest me some solution.

[Dal Jeanis]

And here's a bunch of general notes I put together before I found that post:

So, first, I assume that you would have the relevant MS Office language pack installed. Hindi's a big language grouping, so I would assume that Microsoft would have produced one. http://en.wikipedia.org/wiki/Microso...Language_Packs

Also, that language pack and the regional settings should handle the "code page" aspect of making sure that access can handle storing and processing the Hindi character set. http://support.microsoft.com/kb/140409

For Arabic characters, it looks like some settings must be set to UTF-8. It should be similar for Hindi. http://stackoverflow.com/questions/1...a-browser-page

More about UTF-8 here. http://en.wikipedia.org/wiki/UTF-8

It looks like the Hindi Devanagari characters are in the code range of X'0900'-X'097F' in UTF-8 and take up 3 bytes each for storage, with 8 closely related scripts in the language family taking up the range all the way to X'09FF'. http://en.wikipedia.org/wiki/Mapping...ilingual_Plane

If you're not using native Access, then you need to make sure your ODBC connection supports UTF-8 as well. http://www.mirthcorp.com/community/f...ead.php?t=4608

And there are similar settings for import and export functions to deal with.
http://www.tek-tips.com/viewthread.cfm?qid=1486238

Here's some notes about exporting to a CSV file, if you ever need that.
http://stackoverflow.com/questions/4...-to-utf-16-csv


Here's a site that has some useful VB6 code, some of which may be relevant as you learn more about your situation.
http://www.cyberactivex.com/UnicodeTutorialVb.htm

Here's a related question thread on the forums here. It doens't look like anoyone was able to help the poster, though. https://www.accessforums.net/forms/a...ext-20252.html

Sorry I couldn't help more, but hopefully the above will get your started. As you learn more about how multilanguage support works in Access, please post your hard-earned knowledge back here for others to learn from. If you tell us, step by step, what worked and what didn't, we may be able to be of more help.

[ashish_access]

What I acutally require is to store hindi text from a access form to access database in unicode.
So please let me know how to do it.

And here's a bunch of general notes I put together before I found that post:

So, first, I assume that you would have the relevant MS Office language pack installed. Hindi's a big language grouping, so I would assume that Microsoft would have produced one. http://en.wikipedia.org/wiki/Microso...Language_Packs

Also, that language pack and the regional settings should handle the "code page" aspect of making sure that access can handle storing and processing the Hindi character set. http://support.microsoft.com/kb/140409

For Arabic characters, it looks like some settings must be set to UTF-8. It should be similar for Hindi. http://stackoverflow.com/questions/1...a-browser-page

More about UTF-8 here. http://en.wikipedia.org/wiki/UTF-8

It looks like the Hindi Devanagari characters are in the code range of X'0900'-X'097F' in UTF-8 and take up 3 bytes each for storage, with 8 closely related scripts in the language family taking up the range all the way to X'09FF'. http://en.wikipedia.org/wiki/Mapping...ilingual_Plane

If you're not using native Access, then you need to make sure your ODBC connection supports UTF-8 as well. http://www.mirthcorp.com/community/f...ead.php?t=4608

And there are similar settings for import and export functions to deal with.
http://www.tek-tips.com/viewthread.cfm?qid=1486238

Here's some notes about exporting to a CSV file, if you ever need that.
http://stackoverflow.com/questions/4...-to-utf-16-csv


Here's a site that has some useful VB6 code, some of which may be relevant as you learn more about your situation.
http://www.cyberactivex.com/UnicodeTutorialVb.htm

Here's a related question thread on the forums here. It doens't look like anoyone was able to help the poster, though. https://www.accessforums.net/forms/a...ext-20252.html

Sorry I couldn't help more, but hopefully the above will get your started. As you learn more about how multilanguage support works in Access, please post your hard-earned knowledge back here for others to learn from. If you tell us, step by step, what worked and what didn't, we may be able to be of more help.

[ashish_access]

In access when we store some text in language other than English in the database then it is stored in that language in the database not in unicode.
So when I try to migrate the data from access to SQL Server the data in that field is shown as [][][][]
Please suggest some solution.

And here's a bunch of general notes I put together before I found that post:

So, first, I assume that you would have the relevant MS Office language pack installed. Hindi's a big language grouping, so I would assume that Microsoft would have produced one. http://en.wikipedia.org/wiki/Microso...Language_Packs

Also, that language pack and the regional settings should handle the "code page" aspect of making sure that access can handle storing and processing the Hindi character set. http://support.microsoft.com/kb/140409

For Arabic characters, it looks like some settings must be set to UTF-8. It should be similar for Hindi. http://stackoverflow.com/questions/1...a-browser-page

More about UTF-8 here. http://en.wikipedia.org/wiki/UTF-8

It looks like the Hindi Devanagari characters are in the code range of X'0900'-X'097F' in UTF-8 and take up 3 bytes each for storage, with 8 closely related scripts in the language family taking up the range all the way to X'09FF'. http://en.wikipedia.org/wiki/Mapping...ilingual_Plane

If you're not using native Access, then you need to make sure your ODBC connection supports UTF-8 as well. http://www.mirthcorp.com/community/f...ead.php?t=4608

And there are similar settings for import and export functions to deal with.
http://www.tek-tips.com/viewthread.cfm?qid=1486238

Here's some notes about exporting to a CSV file, if you ever need that.
http://stackoverflow.com/questions/4...-to-utf-16-csv


Here's a site that has some useful VB6 code, some of which may be relevant as you learn more about your situation.
http://www.cyberactivex.com/UnicodeTutorialVb.htm

Here's a related question thread on the forums here. It doens't look like anoyone was able to help the poster, though. https://www.accessforums.net/forms/a...ext-20252.html

Sorry I couldn't help more, but hopefully the above will get your started. As you learn more about how multilanguage support works in Access, please post your hard-earned knowledge back here for others to learn from. If you tell us, step by step, what worked and what didn't, we may be able to be of more help.

[Dal Jeanis]

More data posted on the second thread at
https://www.accessforums.net/forms/p...tml#post179377