Hey all,
So I decided to start fresh on a test machine just to see if I could get
french characters working.
These are my steps:
Freshly Installed Mysql 5.0.45
Configure the MySql Server now
Detailed Configuration
Developer Machine
Multifunctional Database
Online Transaction Processing
Enable
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
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 manual regarding all
Subject: 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
]
To: mysql@lists.mysql.com
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?
--James
- Original
PROTECTED]
To: mysql@lists.mysql.com
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 error when trying to put
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:
My machine with a good old mysql 4.0 crashed last week, and going trough
recovery I ended up with wrong encoding. Right now mysql is on the same version
as before the crash, but at one step data was in newer version of mysql (5.0.x)
and I think that this problem I have originated there. Basically,
Greetings List,
I need some help understanding what is happening with the following
scenario I am going to explain. Please feel free to say RTFM and
point me to a link that can clear this up for me. I have searched
Google with all sorts of different keywords and haven't been able to
figure out
Hi,
Database is MySQL 4.1.5-gamma, running on Linux.
All charset variables are set to default 'latin1', except
'character_set_system', which is utf8.
A database was created and running in this environment, but the data it
gets (from php) were in utf8. Mysqldump is used without any options to
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
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
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:
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
hello...
i'm having some troubles storing data in mysql and thought you can help,
here is my problem:
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.
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
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 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
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
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
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 of the tables
and some of the fields have special characters like
ç õ â .
Is there any way I can set a character set that allows me
to work with it?
All my
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 of the
hi,
i am migrating a legacy java application. so i am not
suppose to change too much things.
the problem is that the app store in multiple language
such as korean and english.
if i load again the new saved data, then korean
language will only be like ',???'
old data are ok. displayed in
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!
Hi fellows,
Thanks for your help. Finally I have the data in the table. But I lost these
special Characters( à ? å ä ); Which when I imported from the text file,
they existed. But I can't find them now by Select statement.
Should I use Character encoding if so, then how?
I am using Java
TT Is it possible to add new 8-bit character encoding to compiled
TT mysql (version 3.23.49-win) without recompiling?
No, you should re-configure and re-compile after adding new character
set. You can read instruction how to add new character set at:
http://www.mysql.com/doc/A/d
Taavi Tiirik asked:
Thanks. Let me put it this way then... There are character set
configuration
files in mysql/share/charsets directory of binary distribution of mysql.
If
these
files cannot be used for defining new character sets then what is their
purpose?
These files are used for
Is it possible to add new 8-bit character encoding to compiled
mysql (version 3.23.49-win) without recompiling?
I would like to add ISO8859-15 encoding that seems not to
be present in default installation.
with best wishes,
Taavi
Taavi,
Monday, April 08, 2002, 3:39:29 PM, you wrote:
TT Is it possible to add new 8-bit character encoding to compiled
TT mysql (version 3.23.49-win) without recompiling?
No, you should re-configure and re-compile after adding new character
set. You can read instruction how to add new
lol list spam filter is quite severe
sql, query
- Original Message -
From: Sylvain Hamel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 14, 2002 3:47 PM
Subject: character encoding problems with org.gjt.mm.mysql jdbc1.0
environment : java jdbc, with MM driver, jdk
Hi All,
I am running Mysql version 2.23.42 on Mac OS X version 10.1.
I need to upload few files in Mysql which are in MacRoman Text Encoding. My
default installation does not support the MacRoman Encoding.
Currently I need to convert the file into ISO-8859-1 encoding before I can
run the LOAD
31 matches
Mail list logo