ADO and Unicode

Introduction

This article explains how to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database.

Overview:

  1. From Unicode.html the user enters a Unicode code point like ! and it's unicode value U0021 and presses submit.
  2. The data transaction occurs in submit_to_database.asp
  3. The data is retrieved using database_results.asp

Important concepts to know about Unicode

  • The Unicode Standard specifies a numeric value and a name for each of its characters.
  • Unicode encodes characters not glyphs (shapes of the character). Multiple glyphs can be assigned to a single character.
  • Unicode is an industrial standard for character presentation.
  • The Unicode Standard provides international exchange of data. Unicode can by stored in a UTF-8 database. UTF-8 is a common encoding schema for exchanging information in HTML and other character file structures.
  • The Unicode Standard provides a standardized character-set, greater exchange of information, and reduction in development costs

You might also like...

Comments

About the author

David Nishimoto United States

NishiSoft provides Part I of the Information Technology Project collaboration. Sign up and list your IT project tasks, assign task too friends, and get percent complete task.

Part will ...

Interested in writing for us? Find out more.

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The generation of random numbers is too important to be left to chance.” - Robert R. Coveyou