Datbase accepting foreign letters?
 

How do I input words into a database while keeping the formatting of the text that I copied with accents, etc.

is what happens.

Tossing, <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" > into the header seems to have fixed it.

Now only question is...is there a way to search using normal letters for a word that maybe contains a accent?

For example, Confederación and Confederation return the same results.

I have run into this same problem on an application I am working on but we are putting it off but will more then likely just remove the accent before entering it into the database because mssql full text search doesnt see them as the same thing, and thats whats being used.

That is due to folding and mapping of characters to a common derivative - which is normally a English-Latin characters (non-accented Latin) due to the dominance of English in programming implementations.

It normally makes sense to add folding, Google for example employ the technique also.

There might be a config option in MSSQL, but in MySQL it's an in-built feature.

For non-FT queries you can do a binary compare:

SELECT * FROM myTable WHERE BINARY title = 'Confederación';

Google soundex