Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    15

    Question Unanswered: create UTF-8 database using enterprise manager sqlserver2000

    Friends

    I know how to create a database using enterprise manager in sql server 7 or 2000.
    But i want to create a database where i have to set the unicode as UTF8 for the whole database.
    is it possible?
    if yes, how can i do that.

    thanks
    sathyguy

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    So you only want it to allow 8 bit OEM values in your database ?!?! No, that is not possible in SQL 2000.

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    15
    thanks for your reply.
    my problem is the new database which im going to create is having some 10 tables. In those 10 tables i have to insert all sorts of languages. ie., chinese, arabic, english etc......
    instead of setting the datatype of each coloumn in each table.
    is there any posssibility to set it for the whole database. i mean the character set for the whole database.

    thanks
    sathyguy

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I think what you really want is SQL N types (including NTEXT) that allow you to store Unicode data.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •