homepage Welcome to WebmasterWorld Guest from 54.205.207.53
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
CTRL+ENTER inside Access and MYSql database
toplisek

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4320717 posted 8:05 pm on Jun 1, 2011 (gmt 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?

 

Demaestro

WebmasterWorld Senior Member demaestro us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4320717 posted 9:12 pm on Jun 1, 2011 (gmt 0)

Are you asking how to store the character equivalent of CTRL+ENTER?

toplisek

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4320717 posted 6:29 am on Jun 2, 2011 (gmt 0)

Yes

coopster

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



 
Msg#: 4320717 posted 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

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4320717 posted 12:51 pm on Jun 2, 2011 (gmt 0)

Yes, it is issue upon import.

coopster

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



 
Msg#: 4320717 posted 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved