Strange character in column

Strange character in column

am 06.06.2007 21:34:19 von Peps

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.

Re: Strange character in column

am 06.06.2007 21:36:41 von Roy Harvey

On Wed, 06 Jun 2007 19:34:19 -0000, Danny 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

Re: Strange character in column

am 06.06.2007 22:15:38 von Peps

On Jun 6, 9:36 am, Roy Harvey wrote:
> On Wed, 06 Jun 2007 19:34:19 -0000, Danny 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.