Post reply

Database of international support

  • August 22, 2007 at 5:55 am

    #153765

    Hello All -

    I need to set up a database with tables which should accept all Asia Pacific languages (Korean, Thai, Chinese). Can anyone share way of configuring database, tables, writing queries to accept these international characters, and best practices?

    Thanks in advance!

    Thanks!

    Viking

  • August 22, 2007 at 6:04 am

    #728500

    nchar and nvarchar columns will have no problems storing these characters. However storing could be a problem. This will affect you if you have any clustered indexes set up on any of these characters. You will probably want to set the collation for the database/table to the most frequently used sorting order.

    For queries much depends on whether you need to sort based on these columns. Same collation rules apply. Query tuning can get a bit painful if you have to connect tables with different collation orders.

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 1 (of 1 total)

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