need to support an asian language db

  • HI,   I need to support a database for an asian customer in their language.  Do I need to install the  Win2k server in their locale ?   Or  is it enough to install SQL 2k server in their locale or  is it enought to create a db in their collation setting, with rest of the system dbs in english ?  Any other thing to take care of ?  The syslanguages already have their codeset as well.  But by default my os and sql  is installed as US English  version. 

    Any other things to take care off, which i have missed ? 

    Thanks much for your help.

    bill

  • I haven't done this, but in my understanding, you can install in English and add the database, table, or even just the columns that you need to support a particular locale.

  • Hi,

    I have done this kind of work in my project. The steps mentioned in below:

    1. Install win2k.

    2. Change locale to corresponding country from Start->controlpanel->Regionalsettings. (Eg Japan)

    3. Then it will ask CD.

    4. Insert the CD and wait for the corresponding Fonts will install into the system.

    5. One it is over then you have to "Restart" the system.

    6. Opne your SQLEditor and Right click on Edition. Then select Fonts from the menu.

    7. Select the desired country language font for viewing purpose. We can do the same for Result Test and Result Grids.

    8. This will work out for your problem

    Cheers,

    Dayakar Ejnavarzala

  • Go ahead and install the proper locale for the OS. It won't hurt and it will always be there if needed. We support over 60 differnt languages so all of my servers install all the of Languages. As I understand, SQL Server 2K has it's own codepaging codes and processes.

    Will your customer be doing Chinese, Japanese, Korean or some other asian langauage or a combination of all? Depending on the answer to that question, you will have to setup the appropriate collation setting on the database. If you have all three languages, then your queries will have to specify the collation setting when called.

    Also, make sure to use the nText, nVarchar and nChar fields and the appropriate N notation in your T-SQL for the inserting of data, otherwise, you will get ??????????? in all of those fields.

    Finally, if you are using a web interface, make sure you are processing all the data/fields there in the appropriate codepage. Otherwise, you will end up with ????????? as the value for those fields.

    Hope this helps.

    SJ

  • Thanks for your replies. Why should I change the region settings of the OS,  or why should I choose a asian collation while installing sql server?

    I have a test environment, contains several dbs for differnent customers, all are in english.   For an asian customer, is it enough to create a db, with that collation, and all the tables with nchar,nvarchar,ntext types ?

  • May be I need to be more clear.  All I need to do is to store data in a db for a asian customer.  only the data will be in that language.    Can't I keep SQL server in the default English collation, so that I can read logs and other stuff in english ? 

     Only when the users in asia, try to view the data they need to be able to see in their language.

  • dayakar, sjhonson,  Please help>

    I added Korean in my regional settings. But english is by default. created a db with a korean collation; created tables with nvarchar,nchar types.  Loaded data from an existing english collation db.  Got into query analyser, rt.clicked on fonts/editors.  I dont see any of the korean fonts there.  We even rebooted the machine after install; Korean also shows up in the regional settings along with english.   What will make me see the data in korean ?  Thanks much.

    bj

  • Did you Install korean language fonts? It seems you are not install that fonts into systems.

    Regional Options --> General --> Language Setting for the system.

    under this you can see more laguages. You need to check "Korean" language.

    By that time it will ask insert CD. Once you have insert the CD then it will copy the required files from it.

    Then restart computer.

    Let me know if you have any concenrs?

    Regards,

    Dayakar E

  • dayakar,

    we checked korean.  It asked for the cd.  we gave it. It seems it copied it. we rebooted the machine.  Now the regional setting contains korean checked.  But I dont see any new fonts in c:\winnt\fonts. 

    same thing in query analyser. the korean fonts dont showup ?  If I do that will i be able to see the data in korean language,  though I inserted in english with N'.....'    ?     thanks for your help

    bj

  • go to explorer-->tools-->Folder options --> view --> please check show hidden files and folder.

    Now you can view the newely installed fonts.

    Please restart the PC.

    Regards,

    Dayakar E

  • Just to verify, can you tell me at least a few font names to be there ?  I am rebooting again...  

  • Hi Bj,

    I came to know that the korean font is "Gulimche". You have to select this font style to view "korean" fonts.

    Hope this will resolve this problem

    Dayakar E

  • Ok. In winnt\fonts I have got Gulim and Gulimche &Dotum & Dotumche   with the file name gulim.ttc

    Now I got into query analyzer, editor, fonts.  It gives me several options:

    Culimche for (central european, baltic, cyrillic, Greek, Hangul, Turkish & western)   which one i should be choosing ?  thanks man!  I got here from nowhere....

  • Do you see Arial Unicode MS? That's what I use so that I never have to change it and it supports almost all of the other languages out there. However, if you are seeing the fonts for Korean, you can use those as well.

    Make sure to set the font for Editor, Results Text and Results Grid/Open Table (those are the result sets you will get back).

    SJ

  • Johnson, I dont see anything as Arial Unicode MS  in the editor of QA.  there is one  Lucida Sans Unicode (Western)  I selected for all the 3 of them. Created a db with Korean_Wansung_CI_AS collation (is this right?)   created a table    create table tmp  (name nvarchar(10))    inserted a record :   insert into tmp values (N'testing')    Now I am giving  select * from tmp.   It gives me:  testing    It is still english.   I thought it will be displayed in korean.  Am I missing something...

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply