Encoding ANSII -> UTF 8

Author Message
playboxy

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 11/1/2010
  • Status: offline
Encoding ANSII -> UTF 8 Monday, November 01, 2010 2:28 AM (permalink)
0
Hi,
 
I've a Problem with Char Encoding...
Maybe you can Help me.

I have a string with ANSII,
but my MYSQL DB needs UTF-8
Do you know, how I can convert this in ASP on Server based VBS?

I tried to convert it in the mysql query, like this:
 query = "Insert Into tbname (ID, value) Values ('" & i & "', CONVERT(_latin1'" & value & " AS CHAR CHARACTER SET utf8));" 

But I don't have any success with this.

thanks
Kai
 
#1
    webber123456

    • Total Posts : 58
    • Scores: 0
    • Reward points : 0
    • Joined: 9/20/2007
    • Status: offline
    Re:Encoding ANSII -> UTF 8 Friday, January 28, 2011 7:13 PM (permalink)
    0
    you may want to move this to a mysql forum for further assistance
     
    #2
      TNO

      • Total Posts : 2094
      • Scores: 36
      • Reward points : 0
      • Joined: 12/18/2004
      • Location: Earth
      • Status: offline
      Re:Encoding ANSII -> UTF 8 Saturday, January 29, 2011 9:44 AM (permalink)
      0
      Use a parametrized query and not string concatenation:
      http://www.w3schools.com/...mm_createparameter.asp
      To iterate is human, to recurse divine. -- L. Peter Deutsch
       
      #3

        Online Bookmarks Sharing: Share/Bookmark

        Jump to:

        Current active users

        There are 0 members and 1 guests.

        Icon Legend and Permission

        • New Messages
        • No New Messages
        • Hot Topic w/ New Messages
        • Hot Topic w/o New Messages
        • Locked w/ New Messages
        • Locked w/o New Messages
        • Read Message
        • Post New Thread
        • Reply to message
        • Post New Poll
        • Submit Vote
        • Post reward post
        • Delete my own posts
        • Delete my own threads
        • Rate post

        2000-2012 ASPPlayground.NET Forum Version 3.9