Hello, I'm using MySQL version 5.0.27 under Windows XP professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where I tried to
insert a swedish character, that character got corrupted. But it works
if I type the
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Wednesday, December 13, 2006 2:03 PM
To: mysql@lists.mysql.com
Subject: MySQL 5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a
riginal Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Thursday, December 14, 2006 2:13 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0.27: character problem
Thanks for the reply, Mr Schwartz. I will see if I can find
some clue on
how to write such a program myse
Thanks for the help, Jerry, I think I solved it. I opened the script (a
standard windows text file) in UltraEdit. It can convert between some
different text formats. After some experimenting it seems that selecting
the conversion ansi-to-oem does the trick! It's now inserted properly
into mysql.
Hello, I'm using MySQL 4.1.10 on Windows XP Pro SP2 (+ all patches on
windowsupdate). I'm using the MySQL C api in a program compiled with MSVC++
7.1.
My program crashes when I call mysql_query() with the following string:
"SELECT * FROM my_recipes WHERE enum_col=0"
Yes, the MYSQL object is vali
"Eric Lilja" wrote:
> Hello, I'm using MySQL 4.1.10 on Windows XP Pro SP2 (+ all patches on
> windowsupdate). I'm using the MySQL C api in a program compiled with
> MSVC++ 7.1.
>
> My program crashes when I call mysql_query() with the following string:
> &q
Hello, I'm a newcomer to MySQL and to databases in general. I'm using MySQL
4.1.9 on a x86-system running Windows XP Pro SP2. I am trying to use the
MySQL C api and I've made the following test program in C (hope the
indentation isn't lost):
#include
#include
#include
static MYSQL m;
static
