Gossamer Forum
Home : General : Databases and SQL :

What is the Line End symbol WITHIN a field?

Quote Reply
What is the Line End symbol WITHIN a field?
I'm trying to use MYSQLMan to import/replace part of a table of data that I extracted from LinksSQL2 using the export table program built within the LINKSQL2 program.

When LinksSQL2 exports a table, it adds the following internal variable %0a to represent a line end within a field. What exactly do I change that to so that MYSQLMan will read that as a line end? If I use it as is my paragraphs within a large text field are destroyed...

Thanks!

Dennis
Dennis
http://www.genealogysurnames.com/
Quote Reply
Re: [perdrix] What is the Line End symbol WITHIN a field? In reply to
\n

...or, in the database you could try running;

UPDATE lsql_Links SET Description = REPLACE(Description,'%0a','\n');

Hope that helps :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!