realbasic-nug
[Top] [All Lists]

Text Encoding Issue from MySQL

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Text Encoding Issue from MySQL
From: Ian R <ian_realbasic at fairmountfair dot com>
Date: Fri, 29 Sep 2006 14:12:21 -0400
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug at lists dot realsoftware dot com

Hey all--

If having a weird issue I've never had before. I'm bringing some text into an editField from a MySQL database. The database is in UTF8, UTF8_general_ci collation. It has "smart quotes" in it, and any place there should be a smart quote (single or double), there is instead a black diamond with a question mark in it. Hm.

Here's the line, in a method of the editField, which puts in the text:

txt = rrr.Field(me.dbField).StringValue
if txt <> "" then me.Text = DefineEncoding(txt,Encodings.UTF8)

If I take out the DefineEncoding stuff (me.Text = txt) then I get the usual foreign-character vowels that I've seen many times.

Any suggestions?

Ian
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>
  • Text Encoding Issue from MySQL, Ian R <=