Sorry, I don't use Perl, so I can't really help with that.  I assume you've already searched for help on this, but here are some that seemed helpful.

http://perl.active-venture.com/pod/perlguts-unicode.html

Did you develop the application, or did you purchase it? I'm pretty sure that the error is a .NET error and not SQL Server.

It appears that the lower case alpha character is only supported in Unicode. Look at this example (The SET statements have the correct alpha, just in case posting this converted...

If [id] is the primary key for table B, then it is not possible to have a NULL [id]. Please post actual CREATE TABLE statements.

Look over this example. This allows multiple null values for the varchar column nulltest, but each non-null must be unique. 

CREATE TABLE NullPKTest

(

  nid int PRIMARY KEY

, nulltest...

Firstly, let me say that I don't have any 64-bit systems. In re-reading the first link [ http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en ] I realized that there is no 64-bit version of SQL Server Express,...

The 36.5 MB file contains only the 32-bit version. The 53.5 MB file contains both the 32-bit and the 64-bit versions.

If you have a function that converts int/binary to a hex string (type varchar), such the one shown below, you could do this to return a string representation of the...

Does the string representation need to be hex? If decimal is ok, look at this example:

DECLARE @bin binary(8)

SET @bin = 0x7FFFFFFFFFFFFFFF

SELECT @bin AS binaryValue

    ...

The value you are trying to insert for column DOWN_TRAFFIC is way too big. DOWN_TRAFFIC is declared as numeric(10,0) and the value you are inserting is 16 digits ( 9702545870094336...

Ronald was correct - your SELECT statement is too big. You are joining 12 or 13 tables (I lost count!), and the total size of all columns selected is too...

Can you post the actual CREATE TABLE statement? The one you posted is invalid. All of the column names are the same, and the last column is missing a closing...

For many errors, SQL Server will continue executing code. It would be up to you to trap certain conditions and then STOP processing. There is no way to cause SQL...

When your language setting is us_english, SQL Server accepts dates in two formats: MDY and YMD. YMD is a "universal" format which accepted regardless of the language setting. That...

This is a cross-post. Continue here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=350095