OT - MySQL, PHP, and Japanese text
N Cueto
nicolas_cueto at yahoo.com
Wed Nov 30 18:45:16 EST 2005
I'm using "put URL tURL" to
call a PHP page, which in
turn accesses a MySQL
database. (Please note that
PHP is the only way my
webhost allows MySQL
administration.)
This was working fine
until I tried selecting
Japanese text, which
is now ending up garbled
at stack level.
If it helps, here's my
script for retrieving
records:
on mouseUp
put "http://webpage.php" into tURL
put URL tURL into tTempResult
replace "<cr>" with cr in tTempResult
replace "," with tab in tTempResult
put empty into tResult
repeat for each line tLine in tTempResult
if tLine is "" then next repeat
put tLine & cr after tResult
end repeat
end mouseUp
What I'm not sure off is:
1) is the "replace ","" command
breaking up the Japanese string?
2) at MySQL admin-level, does
Japanese text require a special
data type or data setting? It's
varchar now.
3) at stack level, is there some
command for setting received-data
type? I'm not sure what I mean
here, other than I've read before
about things like binary encoding
but only with a vague understanding
As always, many thanks for the
advise that, withoug fail, always
arrives generously and kindly
delivered. (I gush a bit because
of the recent negativity about
the docs and some aspect of
RunRev.)
Cheers,
Nicolas Cueto
niconiko language school
More information about the use-livecode
mailing list