Results 1 to 5 of 5

Thread: MSSQL charset problem

  1. #1
    Join Date
    Feb 2009
    Posts
    3

    MSSQL charset problem

    I have a problem with the database on my site, when a recording canhinho to a file in BD, the path is saved type this:

    "upload/introdu??o/galeria/forma??o"

    should be well "upload/introdução/galeria/formação"

    I think this is an error of charset .... how can I change this?

    Thanks

  2. #2
    Join Date
    Feb 2009
    Posts
    3
    Well other question... how can convert a MSSQL tou MySQL?

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    1. You may need save them in unicode column like nvarchar, and put N in front of string like N'upload/introdução/galeria/formação'.

    2. You can cop data from mssql to mysql with ssis package or via linked server.

  4. #4
    Join Date
    Feb 2009
    Posts
    3
    Quote Originally Posted by rmiao View Post
    1. You may need save them in unicode column like nvarchar, and put N in front of string like N'upload/introdução/galeria/formação'.

    2. You can cop data from mssql to mysql with ssis package or via linked server.
    Ok, so I need put in my web page code, when receive the string a letter N before the string? I'm not good in mssql and asp, I good with php and mysql, please can you explaim me better like "Explaim me for dummies" LOL

    Thanks LOL

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    N tells sql this is unicode string, read unicode in sql server books online.

Tags for this Thread

Posting Permissions

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