Results 1 to 3 of 3

Thread: SQL string with space?

  1. Apr 28th, 2006, 02:02 AM #1
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    SQL string with space?

    Hi,
    How do I store a space-containing string in MySQL? When I try to store e.g. "Steffen Sveegaard", MySQL returns an error! The variable is wrapped in "'s in the query.
    Reply With Quote Reply With Quote
  2. Apr 28th, 2006, 02:48 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: SQL string with space?

    What is the error raised?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Apr 28th, 2006, 03:00 AM #3
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Re: SQL string with space?

    "You have an error in your SQL syntax near 'Sveegaard (id int (255) not null primary key auto_increment, dato varchar (75) ' at line 1" while creating a new table
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width