Welcome to WebmasterWorld Guest from 54.226.110.143

Forum Moderators: open

Message Too Old, No Replies

CTRL+ENTER inside Access and MYSql database

     
8:05 pm on Jun 1, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Oct 25, 2006
posts: 1010
votes: 0


I have used CTRL+ENTER (ACCESS Office 2007) and this is not seen inside MYsql table. Is this actually technically possible or how to solve this?
9:12 pm on June 1, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 15, 2003
posts:2606
votes: 0


Are you asking how to store the character equivalent of CTRL+ENTER?
6:29 am on June 2, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Oct 25, 2006
posts: 1010
votes: 0


Yes
12:16 pm on June 2, 2011 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


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?
12:51 pm on June 2, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Oct 25, 2006
posts: 1010
votes: 0


Yes, it is issue upon import.
12:58 pm on June 2, 2011 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


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.