NCHAR, NVARCHAR datatypes and related question

Discussion in 'Databases' started by link_dev, Mar 8, 2008.

0
  1. #1
    Assume my database default language is Chinese and i have a default character set that supports chinese characters,

    1) Can i not store chinese characters in CHAR/VARCHAR datatype columns?
    2) Do i have to use NCHAR/NVARCHAR datatypes only?

    I am confused about NCHAR/NVARCHAR datatypes.
    I know their definitions and differences. I need some explanation from someone who has worked with database servers and internationalization support.

    Thanks
     
    link_dev, Mar 8, 2008 IP
  2. link_dev

    link_dev Peon

    Messages:
    292
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Assume my database default language is Chinese and i have a default character set that supports chinese characters,

    1) Can i not store chinese characters in CHAR/VARCHAR datatype columns?

    If i want to store Japanese characters, Can i do that using NCHAR/NVARCHAR datatypes with above configuration?

    I am confused about NCHAR/NVARCHAR datatypes.
    I know their definitions and differences. I need some explanation from someone who has worked with database servers and internationalization support.

    Thanks
     
    link_dev, Mar 9, 2008 IP
  3. flippers.be

    flippers.be Peon

    Messages:
    432
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Just test it ?
    Install a db on a testmachine and see if you can insert and retrieve everything that you want.

    (and no I don't have experience with chinese/japanese characters)
     
    flippers.be, Mar 10, 2008 IP