Re: [SQL] Insert problem

2008-03-10 Thread Steve Midgley
At 09:20 AM 3/10/2008, [EMAIL PROTECTED] wrote: Date: Mon, 10 Mar 2008 00:14:12 + From: Jamie Tufnell [EMAIL PROTECTED] To: pgsql-sql@postgresql.org Subject: Re: Insert problem Message-ID: [EMAIL PROTECTED] [snip] table defination create sequence schItem_item_seq create table schItem

[SQL] Insert problem

2008-03-09 Thread A. R. Van Hook
I have a table where some of the entries of should have been posted to the wrong cusid and item#: cusid | item# | 1747 | 149 | 9251 : Jonathon Krinke ... 1747 | 150 | 10071 : Lindsey Steele 1747 | 151 | 10187 : Lindsay Stapley ... 1747 | 152 | 10188 : Amanda

Re: [SQL] Insert problem

2008-03-09 Thread Jamie Tufnell
On 3/9/08, A. R. Van Hook [EMAIL PROTECTED] wrote: The script worked fine untill I tried in on the following entries: 1841 | 2 | 9228 : Caty Case : SO:Bra:. 1841 | 3 | 9621 : Kelsie Greenlee : PROM. 2072 | 3 | null : Cookie Jared Cook :.. 2072 | 4 | null : Cookie Jared Cook

Re: [SQL] insert problem with special characters

2003-05-14 Thread Randall Lucas
Hi John, (added to JDBC list) 1. What is your database encoding? Does it support the unicode OK? 2. Are you sure it's getting /stored/ as a question mark rather than just displayed as such? Remember, if it is stored correctly, but you look at it from a terminal that doesn't support the