Hi James,
set these and try again
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 11/9/07, James Sherwood <[EMAIL PROTECTED]> wrote:
>
> Hey all,
>
> So I decided to start fresh on a test machine just to see if I could get
> french
James Sherwood wrote:
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is
defaulted to that I beleive.
Is there a way to dump it to utf8?
You can convert it using iconv:
http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-conten
erwood" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 07, 2007 7:37 PM
Subject: Re: Character encoding problem
Hello,
After I dump the database in and change everything to utf8(or if I try to
dump and make them all utf8 on the dump) I get an "incorrect string
value&q
erwood" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 07, 2007 6:16 PM
Subject: Re: Character encoding problem
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted
to that I beleive.
Is there a way to dump it to utf8?
--Jam
ct: Re: Character encoding problem
James Sherwood wrote:
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on
the character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all scre
James Sherwood wrote:
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on
the character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the
Karima Velasquez wrote:
uhmmm...
i'll give a try to mysql_real_escape_string(), which i understand
formats the data into a valid sql string (without any special
characters, like \ and ' ).
shoud i use an analog function when retriving the data? because if i
"encode" the data, shouldn't i "deco
uhmmm...
i'll give a try to mysql_real_escape_string(), which i understand formats
the data into a valid sql string (without any special characters, like \ and
' ).
shoud i use an analog function when retriving the data? because if i
"encode" the data, shouldn't i "decode" it?
if so, which
Karima Velasquez wrote:
character is: \ (backslash).
Of course that will cause problems. This is the escape character in
SQL, used extensively when inserting BLOB data. Again, I believe
MySQL++ would have prevented this problem, because its escape
manipulator would have escaped the backsla
thanks to Warren for his comment on the examples...
i modified my code trying to get rigth result, but still no luck. doing a
deeper research on comparing the data stored into the database and the data
stored in the wav file at the same time, i notice that there is a character
that is not prope
Karima Velasquez wrote:
do you know about any sample code on
using BLOB columns using c++ to create querys???
C++, eh? I happen to be the MySQL++ maintainer. Two of its example
programs, cgi_image and load_file, deal with BLOBs.
http://tangentsoft.net/mysql++/
Notice the automatic
thanks for answering...
i already know about these datatype, actually i'm using longblob as
datatype; which is why i don't really understand what's going on!!!
regarding on your previous message, do you know about any sample code on
using BLOB columns using c++ to create querys???
best regards
Karima Velasquez wrote:
i know about the null terminating character, but i don't think this is the
problem.
It might not be your immediate problem, but you will run into it eventually.
rigth data: <82>
wrong data:
rigth data: ^
wrong data:
That should only happen if your column is set
i know about the null terminating character, but i don't think this is the
problem. comparing with the wav file, i notice that there are some
characters changed, e.g.
rigth data: <82>
wrong data:
rigth data: ^
wrong data:
so, i don't think that this is the main issue that i'm facing here..
Karima Velasquez wrote:
i'm capturing raw audio/video data and want to store it into mysql. in my
c++ program i create the query to do this, i use sprintf to create this
query using %s format for the printing.
Um, you are aware that C strings (which sprintf uses) are
null-terminated, and th
Hello.
Have you been at:
http://dev.mysql.com/doc/mysql/en/charset-upgrading.html
"An$lia Louren$o" <[EMAIL PROTECTED]> wrote:
> Hi all!
>
> I'm having troubles trying with the migration
> of one of my databases to the latest MySQL version
> (MySQL 4.1). My problem is that some
in addition i also need to save and load korean,
simplified chinese, traditional chinese, japanese and
english in the same record.
have any suggestion ?
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.y
17 matches
Mail list logo
