I use from a shared module.
Function GetStringUTF8(Extends df as DatabaseField) As String
if df = nil then
// to protect us from NIL DatabaseFields
return ""
end if
dim h as string
h = df.getString
if h.Encoding = nil then
Return DefineEncoding(h, Encodings.UTF8)
end
Return h
Exception
msgbox "Exception error"
End Function
At 4:14 PM +1100 18/12/06, Tom Benson wrote:
Thorsten,
entirely untired, but have you tried using this to retrieve string values??
result = DefineEncoding(recordset.field(columname).stringvalue,Encodings.UTF8)
I agree the REALbasic/MySQL database API is neglected, but I don't
think we're going to be offered the chance of picking up table
encodings through the standard API for a long time to come (ever...).
- Tom
On 18/12/2006, at 5:45 AM, Thorsten Hohage wrote:
Hi,
perhaps I miss a new or hidden feature, but I've a massive issue
with encodings and e.g. german umlauts.
Database is mySQL 5.0.x and the encoding of the table and the
column is set to "utf8_unicode_ci" if I insert an umlaut using
phpMySQL then they appear in correct encoding in the database and
could also be exported in correct encoding e.g. to a UTF-8 textfile.
Using RB the encoding of rs.StringValue is always set to US-ASCII
and of course the resulting String is damaged. If I only use RB and
Econding-Functions then everything seems fine on the first look,
but in the database all umlauts are replaced by "funky two
char"-chars and so of course I'm not able to export anything using
e.g. a database dump.
IMHO RB is missing an ".Encoding" function here as e.g. the
TextInputStream do have.
Using e.g. ISOLatin1-Encoding in the database an changing the
enconding Methods in my code, everything is fine, but I'v the need
to store Unicode and not ISOLatin1 chars only, so that's not a real
option.
If I miss something here, I'm really happy that someone can advice
me to the right direction.
regards
Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany
_______________________________________________
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>
_______________________________________________
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>
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
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>
