I am attempting to set the UnicodeCompress ion property via code. The
following line "appears" to work:
tdf.Fields("Sta te").Properties ("UnicodeCompre ssion").Value =
True
I can see the boolean in the property sheet change from No to Yes.
However, the behavior has not changed at all. It still behaves as
though it were set to No. When I change the boolean in the property
sheet GUI it behaves as expected. Any thoughts?
TIA
Bill 5 4524
Bill,
On 7 Nov 2003 08:08:28 -0800, wg****@draper.c om (Bill Grigg) wrote in
comp.databases. ms-access: I can see the boolean in the property sheet change from No to Yes. However, the behavior has not changed at all. It still behaves as though it were set to No. When I change the boolean in the property sheet GUI it behaves as expected. Any thoughts?
Can you be a little more specific about what 'behavior' you are using
for your testing here? Are you checking the contents of this text
field in a hex editor to see whether unicode compression is enforced?
Are you checking file size of the db before and after? What test are
you referring to when you conclude that the unicode compression is not
working when the property is set through code?
Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051
"Peter Miller" <pm*****@pksolu tions.com> wrote in message
news:0b******** *************** *********@4ax.c om... Bill,
On 7 Nov 2003 08:08:28 -0800, wg****@draper.c om (Bill Grigg) wrote in comp.databases. ms-access:
I can see the boolean in the property sheet change from No to Yes. However, the behavior has not changed at all. It still behaves as though it were set to No. When I change the boolean in the property sheet GUI it behaves as expected. Any thoughts?
Can you be a little more specific about what 'behavior' you are using for your testing here? Are you checking the contents of this text field in a hex editor to see whether unicode compression is enforced? Are you checking file size of the db before and after? What test are you referring to when you conclude that the unicode compression is not working when the property is set through code?
And, is it by chance a memo field?
TC
Sorry, I should have given a little more detail. It is a text field. The
behavior has to do with what appears to spaces padded on the right to
fill out the field to whatever size is specified. More specifically, I
noticed that when Unicode Compression is off, and I have a text field of
say 50 characters, and I enter lets say 3 characters into the field that
it is padded with 47 spaces on the right. I can try to delete the spaces
in lets say table view, but they will not go away. This behavior does
not occur when Unicode Compression is turned on.
Bill
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Well the original problem has been solved. I still do not understand
the behavior described below. What I am doing is updating Access
tables and queries from Visio Enterprise edition where I create ER
diagrams and then either generate or update the Access database from
Visio. After googling around a bit I changed my text field types (in
Visio) from CHAR to TEXT. The padded blank problem is solved, and the
Unicode Compression is still not enabled. The bottom line seems to be
that there are Access table properties that are unviewable from the
property sheet, and unprogrammable from VBA.
Bill
Bill Grigg <wg****@draper. com> wrote in message news:<3f******* **************@ news.frii.net>. .. Sorry, I should have given a little more detail. It is a text field. The behavior has to do with what appears to spaces padded on the right to fill out the field to whatever size is specified. More specifically, I noticed that when Unicode Compression is off, and I have a text field of say 50 characters, and I enter lets say 3 characters into the field that it is padded with 47 spaces on the right. I can try to delete the spaces in lets say table view, but they will not go away. This behavior does not occur when Unicode Compression is turned on.
Bill
Well, presumeably CHAR is a >fixed length< field in Visio?
TC
"Bill Grigg" <wg****@draper. com> wrote in message
news:d7******** *************** ***@posting.goo gle.com... Well the original problem has been solved. I still do not understand the behavior described below. What I am doing is updating Access tables and queries from Visio Enterprise edition where I create ER diagrams and then either generate or update the Access database from Visio. After googling around a bit I changed my text field types (in Visio) from CHAR to TEXT. The padded blank problem is solved, and the Unicode Compression is still not enabled. The bottom line seems to be that there are Access table properties that are unviewable from the property sheet, and unprogrammable from VBA.
Bill
Bill Grigg <wg****@draper. com> wrote in message
news:<3f******* **************@ news.frii.net>. .. Sorry, I should have given a little more detail. It is a text field. The behavior has to do with what appears to spaces padded on the right to fill out the field to whatever size is specified. More specifically, I noticed that when Unicode Compression is off, and I have a text field of say 50 characters, and I enter lets say 3 characters into the field that it is padded with 47 spaces on the right. I can try to delete the spaces in lets say table view, but they will not go away. This behavior does not occur when Unicode Compression is turned on.
Bill This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JJ |
last post by:
Hi,
usually, I'm not using MS servers, but I have a big problem with a
Access table.
I should create a web application for a Historical Dipartment.
They have create a populated a Access database using unicode
compression field (for ancient language).
I would like to export this table into MySQL o Postgres, but it's
|
by: JJ |
last post by:
Hi,
usually, I'm not using MS servers, but I have a big problem with a
Access table.
I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).
I would like to export this table into MySQL o Postgres, but it's
|
by: deko |
last post by:
Is it best practice to set Unicode Compression to "No" for memo fields in a
table? What about text fields?
According to the VB help entry:
"Data in a Memo field is not compressed unless it requires 4,096 bytes or
less of storage space after compression. As a result, the contents of a Memo
field might be compressed in one record, but might not be compressed in
another record."
|
by: dixie |
last post by:
I am writing some vba to create a new field if it is not already there.
Code follows.
The code I have so far, creates the new field in the table and sets the
AllowZeroLength property = true.
'Start code
Private Sub AddNewField_Click()
On Error GoTo ErrAddNewField_Click
|
by: Gene |
last post by:
I have a Windows Form control that I have embedded in an ASP.NET page.
I now have the need to catch an event from the control on the webpage.
After researching the situation I found that this is the way to expose
events. I added the following code to my class.
Imports System.IO
Imports Assetta.ColumnStyles
Imports ICSharpCode.SharpZipLib.Zip.Compression
Imports ICSharpCode.SharpZipLib.Zip.Compression.Streams
| |
by: jazaret |
last post by:
I've been having a hard time getting the benefits that Unicode
Compression offers (2003 Access). I've got a test database that I'd
like to set the Unicode Compression for the fields. For this test I've
got a simple table with 16 text fields with size 255 each.
Now I'd like to modify the UC property in code. One of them with DAO
like so...
Set db = CurrentDb()
Set tdef = db.TableDefs("Testtable")
|
by: D |
last post by:
I have a winforms app that I'm reading some records from a datareader and
writing them out to a file like so
SqlDataReader dataReader = sqlCommand.ExecuteReader();
TextWriter textWriter = new StreamWriter(strFileName);
while(drReader.Read())
{
strRecord = ////// strRecord building stuff here
textWriter.WriteLine(strRecord);
iRecordCount++;
|
by: maport |
last post by:
The behavior of the unicode built-in function when given a unicode
string seems a little odd to me:
u'abc'
Traceback (most recent call last):
File "<stdin>", line 1, in ?
TypeError: decoding Unicode is not supported
I don't see why providing the encoding should make the function behave
|
by: Chameleon |
last post by:
I am trying to #define this:
#ifdef UNICODE_STRINGS
#define UC16 L
typedef wstring String;
#else
#define UC16
typedef string String;
#endif
....
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |