Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Location
    india
    Posts
    10

    Unanswered: how to return UTF 8 string from nvarchar field

    hi

    i have connected my ms sql 2000 with C using ODBC

    can u help me to return the utf 8 string from nvarchar field ??
    how should i do it
    please help!!!!!!!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://support.microsoft.com/default...NoWebContent=1 information about storing UTF8 data.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    india
    Posts
    10

    thanx ! but could not hel

    hi

    thanx for u r help but it did not solve my problem
    i want to retrive the utf 8 stirngs stored in nvarchar
    but this does not help

    thanx hope u can help me

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    In SQL you can use READTEXt/WRITETEXT/UPDATETEXT to retrieve such data and refre to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Location
    india
    Posts
    10

    hi

    hi
    thanx a lot
    can u tell me which book to look for and

    what i am saying is that the UTF 8 data that i have stored in the nvarchar field and retrieved it from C and store in a txt file
    it should give ?? it only gives me ? which means it is not reading the whole data
    so can u help in that plzzz
    thanx a lot
    looking forward to u r reply

    thanx

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    IN which language you're trying to retrieve C or SQL?
    Ensure the windows locale does match to the collation set on SQL server.

    Books online is the utility installed alongwith SQL server.
    If not get the latest from here
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Mar 2004
    Location
    india
    Posts
    10

    hi

    i am retrieving the data from MS SQL(back end) through ODBC using C language(front end)
    in win2k envoironment and storing the data in a text file
    the field is a nvarchar field which has UTF 8 chars in it
    and i want to retrieve the data from it and but it is not working accordingly
    what should i do ??

Posting Permissions

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