Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread Grigore Dolghin
What about names containing accents? On Fri, Feb 10, 2012 at 11:53 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Provider has sent me raw data files, plus layouts. Schema defined in > layout files indicates that some fields are NCHAR and NVARCHAR. Lookin

RE: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread Tracy Pearson
MB Software Solutions, LLC wrote on 2012-02-10: > Provider has sent me raw data files, plus layouts. Schema defined in > layout files indicates that some fields are NCHAR and NVARCHAR. Looking > up those 2 online, I see that they're for UNICODE data. If this data > (healthcare claims) is a

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread Stephen Russell
On Fri, Feb 10, 2012 at 3:53 PM, MB Software Solutions, LLC wrote: > Provider has sent me raw data files, plus layouts.  Schema defined in > layout files indicates that some fields are NCHAR and NVARCHAR.  Looking > up those 2 online, I see that they're for UNICODE data.  If this data > (healthcar

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread MB Software Solutions, LLC
On 2/10/2012 5:11 PM, Tracy Pearson wrote: > MB Software Solutions,LLC wrote on 2012-02-10: >> Provider has sent me raw data files, plus layouts. Schema defined in >> layout files indicates that some fields are NCHAR and NVARCHAR. Looking >> up those 2 online, I see that they're for

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread MB Software Solutions, LLC
On 2/11/2012 12:03 AM, MB Software Solutions, LLC wrote: > On 2/10/2012 5:11 PM, Tracy Pearson wrote: >> MB Software Solutions, LLC wrote on 2012-02-10: >>>Provider has sent me raw data files, plus layouts. Schema defined in >>>layout files indicates that some fields are NCHAR and NV

RE: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-11 Thread John Weller
Subject: Re: NCHAR and NVARCHAR fields in TXT/CSV files > > On 2/10/2012 5:11 PM, Tracy Pearson wrote: > > MB Software Solutions, LLC wrote on 2012-02-10: > >> Provider has sent me raw data files, plus layouts. Schema defined in > >> layout files indicates

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-11 Thread Ed Leafe
On Feb 11, 2012, at 10:59 AM, John Weller wrote: > The perils of bottom posting No, the perils of being lazy about trimming. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/pr

RE: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-11 Thread Tracy Pearson
John Weller wrote: >The perils of bottom posting > >John Weller That's right. I had trimmed the message, just not enough. I have customers in the US that enter in Korean names into the tables. -- Tracy Pearson PowerChurch Software Sent with K-9 Mail. __

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-13 Thread MB Software Solutions, LLC
On 2/11/2012 1:02 PM, Ed Leafe wrote: > On Feb 11, 2012, at 10:59 AM, John Weller wrote: > >> The perils of bottom posting > > No, the perils of being lazy about trimming. Aah, but I *DID* trim, everything as I usually do to the bottom of the previous post. For some reason, it did NOT wor

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-13 Thread MB Software Solutions, LLC
On 2/13/2012 11:42 AM, MB Software Solutions, LLC wrote: > On 2/11/2012 1:02 PM, Ed Leafe wrote: >> On Feb 11, 2012, at 10:59 AM, John Weller wrote: >> >>> The perils of bottom posting >> >> No, the perils of being lazy about trimming. > > > Aah, but I *DID* trim, everything as I usually do to