SQL Server Performance

Multi Language Character Support

Discussion in 'General DBA Questions' started by rhankin, Mar 12, 2007.

  1. rhankin New Member

    I have a SQL 2000 Server set up with Latin1_General_BIN collation. I need to allow polish characters on this server but am unaware of how to allow it.

    I have created a new DB using Polish_BIN collation but the only way i can enter polish characters is using nchar for unicode support.
    Our ERP system uses non-unicode char fields for it's text data.

    I have even tried installing polish language support in windows, changing my sql login to polish language and even used "Set Language Polish" to change my server default language and it still only works in unicode

    If anyone is able to tell me how I can enable this polish support on my server I would be very grateful

    Thanks
  2. Adriaan New Member

    You can insert all varchar characters in an nvarchar column, so what is the problem?
  3. rhankin New Member

    Unfortunately I can not change any of the table structures of our ERP system so I can not change from char to nchar
  4. Adriaan New Member

    What does the ERP system have to do with the data types in your new SQL Server database? If you're moving data between the two, you will probably run into conversion issues.

    What platform does the ERP system use?
  5. rhankin New Member

    The DB is for the ERP system. It will sit as another company within our ERP.

    The ERP connects to one SQL DB which tells it where all of the companies are (1 DB per company)

    I just need this new company to support polish characters without affecting the existing companies

    I can't even install it on a seperate SQL instance - all DBs must exist in one instance

    Thanks
  6. Adriaan New Member

    "The ERP connects to one SQL DB which tells it where all of the companies are (1 DB per company)"

    Do you mean real-world address details? An NVARCHAR column will have no problems holding ASCII characters, so you can have both ASCII and Unicode data.

    Are you coming from an Oracle background? Then the technical stuff is perhaps less complicated than what you were expecting.
  7. rhankin New Member

    I can not change the table fields from char to nchar - if i change any data fields at all I invalidate my support agreement

    I am purely from a SQL background

    Cheers
  8. Adriaan New Member

    Not 100% sure I can follow you - now you are changing the ERP system itself, but before you were creating your own database. Anyway ...

    It seems like you have an ERP system in which you need to store data that includes Polish characters. Clearly enough, the ERP system does not support Polish characters. That's an issue that you have to take up with the supplier of the ERP system.
  9. dineshasanka Moderator

    if you can't change the db fields, you will not be able to store multi natioanl charators

    you must have nvarchar,ncchar and ntext file types

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  10. rhankin New Member

    In the ERP system, the way you create a new company is to create a new db, then use the erp system to populate the DB with tables

    So I am creating a new DB and changing the ERP.

    The problem is not the ERP - it is the Database. Forgetting any involvement of the ERP, the problem I have is simply the need to write polish characters into a SQL Field which is char not nchar

    Thanks
  11. rhankin New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by dineshasanka</i><br /><br />if you can't change the db fields, you will not be able to store multi natioanl charators<br /><br />you must have nvarchar,ncchar and ntext file types<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I was afraid of this..... [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]
  12. Adriaan New Member

    quote:Originally posted by rhankin
    Forgetting any involvement of the ERP, the problem I have is simply the need to write polish characters into a SQL Field which is char not nchar
    There is no "simply" here - you cannot write Polish characters into a CHAR type column.

    And changing the column data types will not be enough - there are bound to be stored procedures where you would need to change the data type on variablesas well.

    Since the ERP package holds the definitions for creating the other databases, I would say that this is an issue that only the supplier of the ERP can resolve.

Share This Page