Strange character in column

#1

I saw the strangest thing when I imported some data into a column
today. One column contained musical notes instead of data. Has anyone
ever seen anything like this? I have no idea where this came from.

Thanks in advance.

#2

On Wed, 06 Jun 2007 19:34:19 -0000, Danny <dlapitan (AT) gmail (DOT) com> wrote:

Quote:

I saw the strangest thing when I imported some data into a column
today. One column contained musical notes instead of data. Has anyone
ever seen anything like this? I have no idea where this came from.

Thanks in advance.

What was used to import the data? The problem is in the import
process. Look for data type mismatches, including ASCII vs Unicode.

Roy Harvey
Beacon Falls, CT

#3

On Jun 6, 9:36 am, Roy Harvey <roy_har... (AT) snet (DOT) net> wrote:

Quote:

On Wed, 06 Jun 2007 19:34:19 -0000, Danny <dlapi... (AT) gmail (DOT) com> wrote:
I saw the strangest thing when I imported some data into a column
today. One column contained musical notes instead of data. Has anyone
ever seen anything like this? I have no idea where this came from.

Thanks in advance.

What was used to import the data? The problem is in the import
process. Look for data type mismatches, including ASCII vs Unicode.

Roy Harvey
Beacon Falls, CT

Thanks, Roy, It was indeed a mismatch.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Strange character in column

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Strange character in column - 06-06-2007 , 02:34 PM

Re: Strange character in column - 06-06-2007 , 02:36 PM

Re: Strange character in column - 06-06-2007 , 03:15 PM