Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: Empty text field returning x

Subject: Empty text field returning x

2007-06-06       - By Wendy Schuman

 Back
I am using the MySQL ODBC driver version 3.51 to export data from MySQL
version 3.23 to SQL Server 2005 and am having problems with text fields
with an empty string being returned with an 'x'. I have done a lot of
searching and have not found anyone else that seems to have this
problem, so I'm assuming I must have a setting wrong in my driver. I've
gone in to the driver settings and checked/unchecked any settings that I
thought could be related, but each time the same results were returned.
I would appreciate any help you could provide.



I'm using the Openquery function in SQL Server to execute the query.



Below is my very simple select query which when Field2 and Field3
actually contain an empty space, but is being returned as an x:



SELECT * FROM OPENQUERY(LinkedServer, 'SELECT Field2, Field3

                       FROM MySQLTable WHERE Field1 = 49')



Thanks,

Wendy Schuman