Save and show Strings from all users. /ASP

webstaffuk wrote:
> Hi Steve Its an Access 2003 database, Not sure where to find out what the collation is can you guide me as to where to look?

Ahh, I don't think Access databases use it the same as MS SQL or MySQL.

Do you know the difference between varchar and nvarchar data types? If
your using UTF-8 and wanting to store extended information then you
should be using nvarchar. The N means it stores 2 bytes of information,
not 1, per character.

Thats assuming these data types even exist in Access 2003...I don't have
it so can't really help on that.

Steve

Hi Steve Its an Access 2003 database, Not sure where to find out what the collation is can you guide me as to where to look?

webstaffuk wrote:
> Hi Steve,
> They get entered as 'adVarWChar' generally these fields are for names and
> similar strings.. sometimes i have them as memo fields in the database and they
> are set to go in as 'adLongVarWChar'
>
> Regards
>

What database are you using? What is the collation of your database set to?

Steve

Hi Steve,
They get entered as 'adVarWChar' generally these fields are for names and similar strings.. sometimes i have them as memo fields in the database and they are set to go in as 'adLongVarWChar'

Regards

webstaffuk wrote:
> Hi,
> I wonder if someone can help or advise , Im using DW CS3 and have a few forms
> that are on asp pages.
>
> These forms take a users input and save it to a database then display it on
> another page if needed.
>
> This is all fine except when a user outwith the UK enters something and seem
> to add odd chars into the text boxes or accents from french input or
> apostrophies that differ from UK keyboards....
>
> Is there a generic setting or similar that I can add to my pages to save and
> show anything from anyone?
> Am I missing anything? I use charset=UTF-8 on all of my pages.
>
> Do I need to run a replace function on every text box / area that takes input?
> If I need to use a replace function Can someone advise on this as I have tried
> this a little with not much success...
>
> Or is there something in DV im missing that can aid me?
>
> Thanks again

It might be the datatype you are using for the column in your database.
What are you using?

Steve