HOME | SOLUTIONS | INDUSTRIES | SERVICES | ABOUT US | NEWS & EVENTS | SUPPORT CENTER | CONTACT

 
Product Documentation
Dovetail SelfService
Knowledge Base
Support Forums
Employee Blogs
Contact Us

Enabling Storage of Unicode Data (Article # 253)

View products that this article applies to.

Problem:

The fcSDK is fully Unicode-ready. Fields in your database can be flagged as Unicode fields and the fcSDK  will process data in these columns correctly.



Resolution:

For full details on Enabling Storage of Unicode Data, follow the steps as outlined here:
http://www.dovetailsoftware.com/user_guides/fcSDK/2.2.4/html/fcsdk_unicode.html

Resolution:

Additional Info specific to Clarify version 13

In Clarify version 13 (Amdocs CRM 6), the adp tables have changed.
However, for compatibility purposes, Clarify created views that matched the names of the old adp tables.

So, the SQL given to modify the adp tables will not work in version 13.
Prior to version 13, the following SQL is valid:
alter table adp_sch_info add fc_flags int
As of v13, this is no longer valid because adp_sch_info is now a view, not a table.

A customer supplied the following SQL which he used to make the changes in version 13:

1. ALTER TABLE ADP_FIELD ADD fc_flags INT
2. Add fc_flags to the definition of the view ADP_SCH_INFO, then recompile the view.

CREATE OR REPLACE VIEW ADP_SCH_INFO
(TYPE_ID, FIELD_NAME, CMN_TYPE, DB_TYPE, ARRAY_SIZE,
DEC_P, DEC_S, FLAGS, GEN_FIELD_ID, SPEC_FIELD_ID,
FLD_DEFAULT, COMMENTS, OBJID, DEV, FC_FLAGS)
AS
SELECT
type_id,
field_name,
cmn_type,
db_type,
array_size,
dec_p,
dec_s,
flags,
gen_field_id,
spec_field_id,
fld_default,
comments,
objid,
dev,
fc_flags
FROM ADP_FIELD
/

3. UPDATE adp_sch_info SET fc_flags = 0





Applies To:

  • Dovetail SDKDovetail Software Development Kit for Clarify

Copyright © 2008 Dovetail Software, Inc. All rights reserved.

 

support center | blogs | terms & conditions | contact