Mutlipe Tables and null values

2001-10-28 Thread Jamie Smith
I hope someone can help me out with this problem I have two tables one for users holding all there info each user has a unique ID. I also have a table that records each transaction each transaction has a unique ID and the ID of the user who made the transaction. I whish to do and SQL query that re

Non Ascii characters

2001-10-03 Thread Jamie Smith
I'm having a problem with the sending of the new euro € symbol into the mysql database through a standard SQL stament. I have tried everything cut and paste or ALT 0128 on the command line but all I seem to get is a ? character stored. I know it can be done because I have managed to enter the symb