Demaestro
msg:4320744 | 9:12 pm on Jun 1, 2011 (gmt 0) |
Are you asking how to store the character equivalent of CTRL+ENTER?
|
toplisek
msg:4320880 | 6:29 am on Jun 2, 2011 (gmt 0) |
Yes
|
coopster
msg:4321004 | 12:16 pm on Jun 2, 2011 (gmt 0) |
You can store character sequence strings [dev.mysql.com] like that in your MySQL table columns. Did you import the data and lose the escape sequence upon import?
|
toplisek
msg:4321033 | 12:51 pm on Jun 2, 2011 (gmt 0) |
Yes, it is issue upon import.
|
coopster
msg:4321036 | 12:58 pm on Jun 2, 2011 (gmt 0) |
First, determine whether or not it is an export issue. You can do this by opening up the file in hex mode after exporting it from Access. Search for a known CTRL+ENTER escape sequence and look at the hex representation of the data. Make sure it exists in the exported file. If it's not there, it's obviously not going to show up in your imported records :)
Once you have confirmed that you now have to import it correctly using LOAD DATA INFILE [dev.mysql.com]. Make sure you don't mix up your termination characters with the other sequence characters.
|
|
