Character Sets in 3.23.58

2005-06-23 Thread Andrew Mull
esn't work. Any help would be appreciatedI'm new to this multiple language thing. Thanks! -Andy -- ------ Andrew Mull Tower Communications, LLC 102 Carmen Drive Blandon, PA 19510 Work: 610-926-9734 Cell: 484-794-9433 [EMAIL PROTECTED] www.tower-communic

Copying table to another server.

2005-01-06 Thread Andrew Mull
Hello, I'm having a problem with moving a database from one server to another using mysqldump. Since the servers are different platforms, some ascii characters are getting corrupted. So, my thought was to copy the table from one database to the other via the mysql interface. I found this onl

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
On other instances, " are escaped as \"...I would think that should translate correctly? Thanks Quoting Andrew Mull <[EMAIL PROTECTED]>: > When I look at the dump file, I see that one of the invalid characters is > represented as /226 I'll have to look to see if

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
he standard ascii characters (decimal 39 (') and 34 (")) -- > not "smart quotes"? you shouldn't have any trouble with the standard > quote characters, but as the representation of "smart quotes" isn't > standard you will. > > > -

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
think, you should > find the source of the problem. What odd characters have appeared after > importing? If they are just unreadable, may be the clue is in wrong character > set. > > > > Andrew Mull <[EMAIL PROTECTED]> wrote: > > I'm moving a database from one s

Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
I'm moving a database from one server to another. Both are unix based, however the original database is on a Solaris box, and the new server is RedHat. The database has embedded "s and 's in some of the varchar fields. When I moved the database, I did a mysqldump, copied the text file to the

Re: Unique IDs

2004-12-21 Thread Andrew Mull
UNLOCK > > I don't have time to give a better explanation right now but if you write > the list back, I can fill in the details later. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Andrew Mull <[EMAIL PROTECTED]> wrote on 12/21/

Re: Unique IDs

2004-12-21 Thread Andrew Mull
the FK in Address with the new ID assigned to Person that was created with the merge? Thanks for the help! Quoting Philippe Poelvoorde <[EMAIL PROTECTED]>: > Andrew Mull wrote: > > > I'm working on a rather large database with many cross-linked tables > > c

Unique IDs

2004-12-20 Thread Andrew Mull
I'm working on a rather large database with many cross-linked tables currently using auto increment IDs. The system is primarily a web based system, however, there will be times that the system will be run as a stand alone server...meaning no internet connection is available. The question ar