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

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 Jar

[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 Gou

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 charact